dataSource {
	pooled = true
	driverClassName = "org.postgresql.Driver"
	dialect = org.hibernate.dialect.PostgreSQLDialect
//	logSql = true
	username = "julien"
	password = "000000"
	properties {
//		jmxEnabled = true
		initialSize = 2
		maxActive = 4
		minIdle = 1
		maxIdle = 4
		maxWait = 10000
		maxAge = 60000
//		timeBetweenEvictionRunsMillis = 5000
//		minEvictableIdleTimeMillis = 60000
		validationQuery = "SELECT 1"
		validationQueryTimeout = 3
		validationInterval = 15000
		testOnBorrow = true
		testWhileIdle = true
		testOnReturn = false
//		jdbcInterceptors = "ConnectionState;StatementCache(max=200)"
//		defaultTransactionIsolation = java.sql.Connection.TRANSACTION_READ_COMMITTED
	 }

}
hibernate {
    cache.use_second_level_cache = true
    cache.use_query_cache = true
    cache.provider_class = 'net.sf.ehcache.hibernate.EhCacheProvider'
}
// environment specific settings
environments {
    development {
        dataSource {
            dbCreate = "update" // one of 'create', 'create-drop','update'
            //url = "jdbc:hsqldb:mem:devDB"
			url = "jdbc:postgresql://localhost:5432/SugarBindDB"
        }
    }
    test {
        dataSource {
            dbCreate = "update"
			url = "jdbc:postgresql://localhost:5432/SugarBindDB"
            //url = "jdbc:hsqldb:mem:testDb"
        }
    }
    production {
        dataSource {
            dbCreate = "update"
            url = "jdbc:postgresql://localhost:5432/SugarBindDB"
        }
    }
}
